#创建保存excel
import openpyxl

file = openpyxl.Workbook(write_only=False)
sheet = file.active
sheet.title = 'happy'
#print(file.get_sheet_names())


wb = file.create_sheet('brithday')
wb['A1'] = 'hello word'

for i in range(19):
    wb.append(range(7))

wb2 = file.create_sheet('list')
rows =[
    ['Number','Batch1','Batch2'],
    [2,40,30],
    [3,40,30],
    [4,40,30],
    [5,40,30],
    [6,40,30],
]
for i in rows :
    wb2.append(i)

file.save(filename='./happy.xlsx')